{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Computation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,2],[10,0,10,2],[14,0,14,2],[0,0,0,2],[1,0,1,2],[12,0,12,2],[13,0,13,2],[11,0,11,2]]}
["National Housing Bank"]
["Subsidy Calculator for Pradhan Mantri Awas Yojana – Credit Linked Subsidy Scheme (MIG II)"]
["First Disbursement Date","2017-01-01","Date should be on or after 01-jan-2017"]
["Current Disbursement Date (for which subsidy claimed)","2017-01-01","Date should  be on or after first disbursement date"]
["Loan Tenure (in months)",240,"Numeric Integer only"]
["Current Disbursement Installment (in Rs.)",1200000,"Numeric Integer only"]
["Amount Disbursed before this installment (in Rs.)",0,"Numeric Integer only"]
["Applied Interest Rate for subsidy calculation (in % p.a)",3,"NO input data"]
["Subsidy Amount",230155.6528977548]
[]
["Assumptions:"]
["a. Interest for calculation of subsidy is arrived at by applying interest @ 3% p.a. on the disbursed amount and on monthly rest basis"]
["b. Subsidy is calculated for a maximum tenure of 240 months (20 years) from first disbursement."]
["c. NPV is calculated at the discount rate of 9% and on monthly rest basis."]
["d. Interest Subsidy is calculated for eligible disbursement amount  upto first Rs 12 lakh of loan amount."]
["e. Paisa is rounded off to the nearest rupee in the total"]

{"sheet":"Computation","index":1,"n_rows":243,"n_cols":14,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
["Parameters",null,"Loan Amount",{"$f":"IF((Data!B7+Data!B6)>1200000,1200000-Data!B7,Data!B6)","v":1200000},"Loan Tenure",{"$f":"IF(Data!B5>240,240,Data!B5)","v":240},"Cur Inst Tenure",{"$f":"IF(Data!B4=\"\",0, F1-((YEAR(Data!B4)-YEAR(Data!B3))*12+MONTH(Data!B4)-MONTH(Data!B3)))","v":240},"Int Rate",{"$f":"IF(Data!B8>3,3,Data!B8)","v":3},"r ",{"$f":"J1/1200","v":2.5000000000000001E-3},"(1+r)^n-1",{"$f":"((1+L1)^H1)-1","v":0.82075499531646523}]
[null,"BALANCE","EMI","INTEREST","principal repayment","CL BALANCE","NPV(By Formula)",null,null,"EMI",{"$f":"IF($N$1=0,0,($D$1*$L$1)*((1+$L$1)^$H$1)/$N$1)","v":6655.1711742470306}]
[1,{"$f":"D1","v":1200000},{"$f":"K2","v":6655.1711742470306},{"$f":"B3*$J$1/(1200)","v":3000},{"$f":"C3-D3","v":3655.1711742470306},{"$f":"B3-E3","v":1196344.8288257529},{"$f":"D3/POWER(1+9/1200,A3)","v":2977.6674937965258}]
[{"$f":"A3+1","v":2},{"$f":"IF(F3>0,F3,0)","v":1196344.8288257529},{"$f":"IF(B4>0,C3,0)","v":6655.1711742470306},{"$f":"B4*$J$1/1200","v":2990.8620720643821},{"$f":"C4-D4","v":3664.3091021826485},{"$f":"B4-E4","v":1192680.5197235702},{"$f":"D4/POWER(1+9/1200,A4)","v":2946.49884877255}]
[{"$f":"A4+1","v":3},{"$f":"IF(F4>0,F4,0)","v":1192680.5197235702},{"$f":"IF(B5>0,C4,0)","v":6655.1711742470306},{"$f":"B5*$J$1/1200","v":2981.7012993089256},3673.469874938105,1189007.0498486322,2915.6069052537896]
[4,1189007.0498486322,6655.1711742470306,2972.5176246215806,3682.6535496254501,1185324.3962990067,2884.9893817061993]
[5,1185324.3962990067,6655.1711742470306,2963.3109907475168,3691.8601834995138,1181632.5361155071,2854.6440146802111]
[6,1181632.5361155071,6655.1711742470306,2954.0813402887679,3701.0898339582627,1177931.4462815488,2824.5685586706504]
[7,1177931.4462815488,6655.1711742470306,2944.8286157038724,3710.3425585431582,1174221.1037230056,2794.760785977724]
[8,1174221.1037230056,6655.1711742470306,2935.5527593075144,3719.6184149395162,1170501.485308066,2765.2184865690629]
[9,1170501.485308066,6655.1711742470306,2926.253713270165,3728.9174609768656,1166772.5678470891,2735.9394679428246]
[10,1166772.5678470891,6655.1711742470306,2916.9314196177229,3738.2397546293078,1163034.3280924598,2706.9215549918417,"Total NPV as per Manual Formula",{"$f":"SUM(G3:G242)","v":230155.6528977548}]
[11,1163034.3280924598,6655.1711742470306,2907.5858202311497,3747.585354015881,1159286.7427384439,2678.1625898688026,"NPV by Excel Formula",{"$f":"NPV(9/1200,D3:D242)","v":230155.65289775503}]
[12,1159286.7427384439,6655.1711742470306,2898.2168568461097,3756.9543174009209,1155529.788421043,2649.6604318524692]
[13,1155529.788421043,6655.1711742470306,2888.8244710526074,3766.3467031944233,1151763.4417178486,2621.4129572149127]
[14,1151763.4417178486,6655.1711742470306,2879.4086042946215,3775.7625699524092,1147987.6791478961,2593.4180590897631]
[15,1147987.6791478961,6655.1711742470306,2869.9691978697401,3785.2019763772905,1144202.4771715188,2565.6736473414694]
[16,1144202.4771715188,6655.1711742470306,2860.5061929287972,3794.6649813182335,1140407.8121902007,2538.1776484355587]
[17,1140407.8121902007,6655.1711742470306,2851.0195304755016,3804.1516437715291,1136603.6605464292,2510.9280053098764]
[18,1136603.6605464292,6655.1711742470306,2841.5091513660727,3813.6620228809579,1132789.9985235482,2483.9226772468301]
[19,1132789.9985235482,6655.1711742470306,2831.9749963088707,3823.19617793816,1128966.80234561,2457.1596397465937]
[20,1128966.80234561,6655.1711742470306,2822.4170058640248,3832.7541683830059,1125134.0481772269,2430.6368844012823]
[21,1125134.0481772269,6655.1711742470306,2812.8351204430674,3842.3360538039633,1121291.7121234229,2404.3524187701028]
[22,1121291.7121234229,6655.1711742470306,2803.229280308557,3851.9418939384736,1117439.7702294844,2378.3042662554394]
[23,1117439.7702294844,6655.1711742470306,2793.599425573711,3861.5717486733197,1113578.1984808112,2352.4904659799049]
[24,1113578.1984808112,6655.1711742470306,2783.9454962020282,3871.2256780450025,1109706.9728027661,2326.9090726643149]
[25,1109706.9728027661,6655.1711742470306,2774.2674320069154,3880.9037422401152,1105826.0690605261,2301.55815650661]
[26,1105826.0690605261,6655.1711742470306,2764.5651726513156,3890.606001595715,1101935.4630589304,2276.4358030616968]
[27,1101935.4630589304,6655.1711742470306,2754.8386576473258,3900.3325165997048,1098035.1305423307,2251.5401131222079]
[28,1098035.1305423307,6655.1711742470306,2745.087826355827,3910.0833478912036,1094125.0471944395,2226.8692026001759]
[29,1094125.0471944395,6655.1711742470306,2735.3126179860988,3919.8585562609319,1090205.1886381786,2202.4212024096105]
[30,1090205.1886381786,6655.1711742470306,2725.5129715954467,3929.6582026515839,1086275.530435527,2178.1942583499758]
[31,1086275.530435527,6655.1711742470306,2715.6888260888177,3939.482348158213,1082336.0480873687,2154.1865309905588]
[32,1082336.0480873687,6655.1711742470306,2705.8401202184218,3949.3310540286088,1078386.7170333401,2130.3961955557229]
[33,1078386.7170333401,6655.1711742470306,2695.9667925833505,3959.2043816636801,1074427.5126516765,2106.8214418110347]
[34,1074427.5126516765,6655.1711742470306,2686.0687816291916,3969.1023926178391,1070458.4102590587,2083.4604739502702]
[35,1070458.4102590587,6655.1711742470306,2676.1460256476466,3979.025148599384,1066479.3851104593,2060.31151048328]
[36,1066479.3851104593,6655.1711742470306,2666.1984627761481,3988.9727114708826,1062490.4123989884,2037.3727841247162]
[37,1062490.4123989884,6655.1711742470306,2656.2260309974708,3998.9451432495598,1058491.4672557388,2014.6425416836053]
[38,1058491.4672557388,6655.1711742470306,2646.2286681393471,4008.9425061076836,1054482.5247496311,1992.1190439537727]
[39,1054482.5247496311,6655.1711742470306,2636.2063118740775,4018.9648623729531,1050463.5598872581,1969.8005656051043]
[40,1050463.5598872581,6655.1711742470306,2626.1588997181452,4029.0122745288854,1046434.5476127292,1947.685395075639]
[41,1046434.5476127292,6655.1711742470306,2616.0863690318229,4039.0848052152078,1042395.462807514,1925.7718344644859]
[42,1042395.462807514,6655.1711742470306,2605.988657018785,4049.1825172282456,1038346.2802902857,1904.0581994255676]
[43,1038346.2802902857,6655.1711742470306,2595.8657007257143,4059.3054735213163,1034286.9748167644,1882.5428190621697]
[44,1034286.9748167644,6655.1711742470306,2585.7174370419111,4069.4537372051195,1030217.5210795592,1861.2240358223037]
[45,1030217.5210795592,6655.1711742470306,2575.5438026988982,4079.6273715481325,1026137.8937080111,1840.1002053948678]
[46,1026137.8937080111,6655.1711742470306,2565.3447342700279,4089.8264399770028,1022048.0672680341,1819.169696606604]
[47,1022048.0672680341,6655.1711742470306,2555.1201681700854,4100.0510060769448,1017948.0162619571,1798.4308913198461]
[48,1017948.0162619571,6655.1711742470306,2544.8700406548928,4110.3011335921383,1013837.715128365,1777.8821843310466]
[49,1013837.715128365,6655.1711742470306,2534.5942878209125,4120.5768864261181,1009717.1382419389,1757.521983270087]
[50,1009717.1382419389,6655.1711742470306,2524.2928456048471,4130.878328642184,1005586.2599132967,1737.3487085003537]
[51,1005586.2599132967,6655.1711742470306,2513.965649783242,4141.2055244637886,1001445.0543888329,1717.3607930195853]
[52,1001445.0543888329,6655.1711742470306,2503.6126359720824,4151.5585382749487,997293.49585055793,1697.5566823614724]
[53,997293.49585055793,6655.1711742470306,2493.2337396263947,4161.9374346206359,993131.55841593724,1677.9348344980199]
[54,993131.55841593724,6655.1711742470306,2482.8288960398431,4172.3422782071875,988959.21613773005,1658.4937197426505]
[55,988959.21613773005,6655.1711742470306,2472.3980403443252,4182.773133902705,984776.44300382736,1639.2318206540554]
[56,984776.44300382736,6655.1711742470306,2461.9411075095686,4193.230066737462,980583.21293708985,1620.1476319407786]
[57,980583.21293708985,6655.1711742470306,2451.4580323427249,4203.7131419043053,976379.49979518552,1601.2396603665352]
[58,976379.49979518552,6655.1711742470306,2440.9487494879641,4214.2224247590666,972165.27737042645,1582.5064246562554]
[59,972165.27737042645,6655.1711742470306,2430.4131934260663,4224.7579808209648,967940.5193896055,1563.9464554028468]
[60,967940.5193896055,6655.1711742470306,2419.8512984740137,4235.319875773017,963705.19951383246,1545.5582949746736]
[61,963705.19951383246,6655.1711742470306,2409.2629987845812,4245.9081754624494,959459.29133836995,1527.3404974237453]
[62,959459.29133836995,6655.1711742470306,2398.6482283459245,4256.5229459011061,955202.7683924688,1509.2916283946051]
[63,955202.7683924688,6655.1711742470306,2388.0069209811718,4267.1642532658589,950935.60413920297,1491.4102650339271]
[64,950935.60413920297,6655.1711742470306,2377.3390103480074,4277.8321638990237,946657.771975304,1473.6949959007952]
[65,946657.771975304,6655.1711742470306,2366.6444299382601,4288.5267443087705,942369.24523099524,1456.1444208776757]
[66,942369.24523099524,6655.1711742470306,2355.9231130774883,{"$f":"C68-D68","v":4299.2480611695428},{"$f":"B68-E68","v":938069.99716982571},{"$f":"D68/POWER(1+9/1200,A68)","v":1438.7571510820751}]
[{"$f":"A68+1","v":67},{"$f":"IF(F68>0,F68,0)","v":938069.99716982571},{"$f":"IF(B69>0,C68,0)","v":6655.1711742470306},{"$f":"B69*$J$1/1200","v":2345.1749929245643},4309.9961813224663,933760.00098850322,1421.5318087788723]
[68,933760.00098850322,6655.1711742470306,2334.4000024712582,4320.771171775772,929439.22981672746,1404.4670272933245]
[69,929439.22981672746,6655.1711742470306,2323.5980745418187,4331.5730997052124,925107.6567170223,1387.5614509247387]
[70,925107.6567170223,6655.1711742470306,2312.7691417925557,4342.4020324544745,920765.2546845678,1370.8137348608091]
[71,920765.2546845678,6655.1711742470306,2301.9131367114196,4353.258037535611,916411.99664703221,1354.2225450926101]
[72,916411.99664703221,6655.1711742470306,2291.0299916175809,4364.1411826294498,912047.85546440282,1337.7865583302407]
[73,912047.85546440282,6655.1711742470306,2280.1196386610072,4375.0515355860234,907672.80392881681,1321.5044619191178]
[74,907672.80392881681,6655.1711742470306,2269.1820098220419,4385.9891644249892,903286.81476439186,1305.374953756912]
[75,903286.81476439186,6655.1711742470306,2258.2170369109799,4396.9541373360507,898889.86062705587,1289.3967422111216]
[76,898889.86062705587,6655.1711742470306,2247.2246515676393,4407.9465226793909,894481.91410437645,1273.5685460372758]
[77,894481.91410437645,6655.1711742470306,2236.2047852609412,4418.9663889860894,890062.94771539036,1257.8890942977725]
[78,890062.94771539036,6655.1711742470306,2225.1573692884758,4430.0138049585548,885632.93391043181,1242.3571262813311]
[79,885632.93391043181,6655.1711742470306,2214.0823347760797,4441.0888394709509,881191.84507096082,1226.9713914230733]
[80,881191.84507096082,6655.1711742470306,2202.9796126774017,4452.1915615696289,876739.65350939124,1211.7306492252076]
[81,876739.65350939124,6655.1711742470306,2191.8491337734781,4463.322040473553,872276.33146891766,1196.6336691783326]
[82,872276.33146891766,6655.1711742470306,2180.6908286722942,4474.4803455747369,867801.85112334287,1181.6792306833361]
[83,867801.85112334287,6655.1711742470306,2169.5046278083573,4485.6665464386733,863316.18457690417,1166.8661229739018]
[84,863316.18457690417,6655.1711742470306,2158.29046144226,4496.8807128047702,858819.30386409943,1152.1931450396053]
[85,858819.30386409943,6655.1711742470306,2147.0482596602483,4508.1229145867819,854311.18094951264,1137.659105549606]
[86,854311.18094951264,6655.1711742470306,2135.7779523737813,4519.3932218732498,849791.78772763943,1123.2628227769192]
[87,849791.78772763943,6655.1711742470306,2124.4794693190984,4530.6917049279327,845261.09602271148,1109.0031245232785]
[88,845261.09602271148,6655.1711742470306,2113.1527400567788,4542.0184341902514,840719.07758852118,1094.8788480445667]
[89,840719.07758852118,6655.1711742470306,2101.797693971303,4553.3734802757281,836165.70410824544,1080.8888399768259]
[90,836165.70410824544,6655.1711742470306,2090.4142602706133,4564.7569139764173,831600.94719426904,1067.0319562628356]
[91,831600.94719426904,6655.1711742470306,2079.0023679856727,4576.1688062613575,827024.77838800766,1053.3070620792523]
[92,827024.77838800766,6655.1711742470306,2067.5619459700192,4587.6092282770114,822437.16915973066,1039.7130317643109]
[93,822437.16915973066,6655.1711742470306,2056.0929228993264,4599.0782513477043,817838.0909083829,1026.2487487460846]
[94,817838.0909083829,6655.1711742470306,2044.5952272709571,4610.5759469760733,813227.51496140682,1012.9131054712905]
[95,813227.51496140682,6655.1711742470306,2033.0687874035173,4622.1023868435132,808605.41257456329,999.7050033346494]
[96,808605.41257456329,6655.1711742470306,2021.5135314364084,4633.6576428106218,803971.75493175269,986.62335260878308]
[97,803971.75493175269,6655.1711742470306,2009.9293873293818,4645.2417869176488,799326.51314483501,973.66707237465414]
[98,799326.51314483501,6655.1711742470306,1998.3162828620877,4656.8548913849427,794669.65825345006,960.83509045254038]
[99,794669.65825345006,6655.1711742470306,1986.6741456336254,4668.4970286134048,790001.16122483672,948.12634333354015]
[100,790001.16122483672,6655.1711742470306,1975.0029030620919,4680.1682711849389,785320.99295365182,935.53977611160281]
[101,785320.99295365182,6655.1711742470306,1963.3024823841297,4691.868691862901,780629.12426178891,923.07434241608439]
[102,780629.12426178891,6655.1711742470306,1951.5728106544723,4703.5983635925586,775925.52589819639,910.72900434482199]
[103,775925.52589819639,6655.1711742470306,1939.8138147454911,4715.3573595015396,771210.16853869485,898.50273239772218]
[104,771210.16853869485,6655.1711742470306,1928.0254213467372,4727.1457529002937,766483.02278579457,886.39450541086057]
[105,766483.02278579457,6655.1711742470306,1916.2075569644865,4738.963617282544,761744.059168512,874.40331049108977]
[106,761744.059168512,6655.1711742470306,1904.36014792128,4750.8110263257504,756993.2481421862,862.52814295114911]
[107,756993.2481421862,6655.1711742470306,1892.4831203554656,4762.6880538915648,752230.56008829467,850.76800624527584]
[108,752230.56008829467,6655.1711742470306,1880.5764002207368,4774.5947740262936,747455.96531426837,839.12191190530984]
[109,747455.96531426837,6655.1711742470306,1868.6399132856711,4786.5312609613593,742669.43405330705,827.58887947729193]
[110,742669.43405330705,6655.1711742470306,1856.6735851332678,4798.4975891137628,737870.93646419328,816.16793645854932]
[111,737870.93646419328,6655.1711742470306,1844.6773411604831,4810.493833086548,733060.44263110671,804.85811823526694]
[112,733060.44263110671,6655.1711742470306,1832.6511065777668,4822.5200676692639,728237.92256343749,793.65846802053818]
[113,728237.92256343749,6655.1711742470306,1820.5948064085937,4834.5763678384374,723403.34619559906,782.56803679289317]
[114,723403.34619559906,6655.1711742470306,1808.5083654889977,4846.662808758033,718556.68338684097,771.58588323530068]
[115,718556.68338684097,6655.1711742470306,1796.3917084671025,4858.7794657799277,713697.90392106108,760.7110736746406]
[116,713697.90392106108,6655.1711742470306,1784.2447598026527,4870.9264144443778,708826.97750661673,749.9426820216413]
[117,708826.97750661673,6655.1711742470306,1772.0674437665418,4883.1037304804886,703943.8737761362,739.27978971128198]
[118,703943.8737761362,6655.1711742470306,1759.8596844403407,4895.3114898066897,699048.56228632946,728.72148564365057]
[119,699048.56228632946,6655.1711742470306,1747.6214057158236,4907.5497685312075,694141.01251779823,718.26686612526203]
[120,694141.01251779823,6655.1711742470306,1735.3525312944955,4919.8186429525349,689221.19387484575,707.91503481082611]
[121,689221.19387484575,6655.1711742470306,1723.0529846871143,4932.1181895599166,684289.07568528585,697.66510264546332]
[122,684289.07568528585,6655.1711742470306,1710.7226892132146,4944.4484850338158,679344.62720025203,687.51618780736908]
[123,679344.62720025203,6655.1711742470306,1698.3615680006301,4956.809606246401,674387.81759400561,677.46741565091736]
[124,674387.81759400561,6655.1711742470306,1685.9695439850138,4969.2016302620168,669418.61596374365,667.51791865020436]
[125,669418.61596374365,6655.1711742470306,1673.5465399093591,4981.6246343376715,664436.99132940592,657.66683634302819]
[126,664436.99132940592,6655.1711742470306,1661.0924783235148,4994.0786959235156,659442.91263348237,647.91331527529667]
[127,659442.91263348237,6655.1711742470306,1648.607281583706,5006.5638926633246,654436.34874081903,638.25650894587045]
[128,654436.34874081903,6655.1711742470306,1636.0908718520477,5019.0803023949829,649417.2684384241,628.69557775182602]
[129,649417.2684384241,6655.1711742470306,1623.5431710960604,5031.6280031509705,644385.64043527318,619.22968893414179]
[130,644385.64043527318,6655.1711742470306,1610.9641010881828,{"$f":"C132-D132","v":5044.2070731588483},{"$f":"B132-E132","v":639341.43336211436},{"$f":"D132/POWER(1+9/1200,A132)","v":609.85801652380621}]
[{"$f":"A132+1","v":131},{"$f":"IF(F132>0,F132,0)","v":639341.43336211436},{"$f":"IF(B133>0,C132,0)","v":6655.1711742470306},{"$f":"B133*$J$1/1200","v":1598.3535834052859},5056.8175908417452,634284.61577127257,600.57974128833939]
[132,634284.61577127257,6655.1711742470306,1585.7115394281814,5069.4596348188497,629215.15613645373,591.39405067872644]
[133,629215.15613645373,6655.1711742470306,1573.0378903411345,5082.133283905896,624133.02285254782,582.30013877676322]
[134,624133.02285254782,6655.1711742470306,1560.3325571313694,5094.8386171156617,619038.18423543219,573.29720624280492]
[135,619038.18423543219,6655.1711742470306,1547.5954605885804,5107.5757136584507,613930.60852177371,564.38446026392251]
[136,613930.60852177371,6655.1711742470306,1534.8265213044342,5120.3446529425964,608810.2638688311,555.56111450245396]
[137,608810.2638688311,6655.1711742470306,1522.0256596720778,5133.1455145749533,603677.11835425615,546.82638904495741]
[138,603677.11835425615,6655.1711742470306,1509.1927958856402,5145.9783783613902,598531.13997589471,538.17951035155534]
[139,598531.13997589471,6655.1711742470306,1496.3278499397368,5158.8433243072941,593372.29665158736,529.61971120567182]
[140,593372.29665158736,6655.1711742470306,1483.4307416289685,5171.7404326180622,588200.55621896929,521.14623066415663]
[141,588200.55621896929,6655.1711742470306,1470.5013905474234,5184.6697836996073,583015.88643526973,512.75831400779521]
[142,583015.88643526973,6655.1711742470306,1457.5397160881741,5197.6314581588567,577818.25497711089,504.45521269220018]
[143,577818.25497711089,6655.1711742470306,1444.5456374427774,5210.625536804253,572607.62944030669,496.23618429908441]
[144,572607.62944030669,6655.1711742470306,1431.5190736007667,5223.6521006462644,567383.9773396604,488.10049248790659]
[145,567383.9773396604,6655.1711742470306,1418.459943349151,5236.7112308978794,562147.26610876247,480.04740694789433]
[146,562147.26610876247,6655.1711742470306,1405.3681652719063,5249.8030089751246,556897.46309978736,472.07620335043561]
[147,556897.46309978736,6655.1711742470306,1392.2436577494684,5262.9275164975625,551634.53558328981,464.18616330183937]
[148,551634.53558328981,6655.1711742470306,1379.0863389582246,5276.0848352888061,546358.45074800099,456.37657429646003]
[149,546358.45074800099,6655.1711742470306,1365.8961268700025,5289.2750473770284,541069.17570062401,448.64672967018555]
[150,541069.17570062401,6655.1711742470306,1352.6729392515599,5302.4982349954707,535766.67746562848,440.99592855428386]
[151,535766.67746562848,6655.1711742470306,1339.4166936640713,5315.7544805829593,530450.92298504547,433.42347582960781]
[152,530450.92298504547,6655.1711742470306,1326.1273074626138,5329.0438667844173,525121.87911826104,425.92868208115152]
[153,525121.87911826104,6655.1711742470306,1312.8046977956526,5342.3664764513778,519779.51264180965,418.51086355296104]
[154,519779.51264180965,6655.1711742470306,1299.4487816045241,5355.7223926425067,514423.79024916713,411.16934210339195]
[155,514423.79024916713,6655.1711742470306,1286.0594756229179,5369.1116986241123,509054.67855054303,403.90344516071337]
[156,509054.67855054303,6655.1711742470306,1272.6366963763576,5382.5344778706731,503672.14407267235,396.71250567905514]
[157,503672.14407267235,6655.1711742470306,1259.180360181681,5395.9908140653497,498276.15325860702,389.595862094697]
[158,498276.15325860702,6655.1711742470306,1245.6903831465177,5409.4807911005128,492866.67246750649,382.55285828269365]
[159,492866.67246750649,6655.1711742470306,1232.1666811687662,5423.0044930782642,487443.66797442822,375.58284351383833]
[160,487443.66797442822,6655.1711742470306,1218.6091699360704,5436.5620043109602,482007.10597011726,368.6851724119569]
[161,482007.10597011726,6655.1711742470306,1205.0177649252932,5450.1534093217379,476556.95256079553,361.85920491153365]
[162,476556.95256079553,6655.1711742470306,1191.3923814019888,5463.7787928450416,471093.1737679505,355.10430621566462]
[163,471093.1737679505,6655.1711742470306,1177.7329344198763,5477.4382398271546,465615.73552812333,348.41984675433758]
[164,465615.73552812333,6655.1711742470306,1164.0393388203083,5491.1318354267223,460124.6036926966,341.80520214303283]
[165,460124.6036926966,6655.1711742470306,1150.3115092317414,5504.8596650152895,454619.7440276813,335.25975314164663]
[166,454619.7440276813,6655.1711742470306,1136.5493600692034,5518.6218141778272,449101.12221350346,328.78288561373131]
[167,449101.12221350346,6655.1711742470306,1122.7528055337586,5532.4183687132718,443568.70384479017,322.3739904860517]
[168,443568.70384479017,6655.1711742470306,1108.9217596119754,5546.2494146350555,438022.45443015511,316.032463708455]
[169,438022.45443015511,6655.1711742470306,1095.0561360753879,5560.1150381716425,432462.33939198346,309.75770621405036]
[170,432462.33939198346,6655.1711742470306,1081.1558484799586,5574.0153257670718,426888.32406621642,303.54912387969813]
[171,426888.32406621642,6655.1711742470306,1067.220810165541,5587.9503640814892,421300.37370213494,297.40612748680519]
[172,421300.37370213494,6655.1711742470306,1053.2509342553374,5601.9202399916931,415698.45346214325,291.32813268242268]
[173,415698.45346214325,6655.1711742470306,1039.2461336553581,5615.9250405916728,410082.52842155157,285.31455994064703]
[174,410082.52842155157,6655.1711742470306,1025.206321053879,5629.9648531931516,404452.56356835843,279.36483452431867]
[175,404452.56356835843,6655.1711742470306,1011.1314089208962,5644.0397653261343,398808.52380303229,273.47838644701875]
[176,398808.52380303229,6655.1711742470306,997.02130950758078,5658.1498647394501,393150.37393829285,267.65465043535931]
[177,393150.37393829285,6655.1711742470306,982.87593484573222,5672.2952394012982,387478.07869889156,261.89306589156701]
[178,387478.07869889156,6655.1711742470306,968.69519674722881,5686.475977499802,381791.60272139177,256.19307685635545]
[179,381791.60272139177,6655.1711742470306,954.47900680347948,5700.6921674435507,376090.9105539482,250.55413197208773]
[180,376090.9105539482,6655.1711742470306,940.22727638487049,5714.9438978621602,370375.96665608604,244.97568444622158]
[181,{"$f":"IF(F182>0,F182,0)","v":370375.96665608604},{"$f":"IF(B183>0,C182,0)","v":6655.1711742470306},{"$f":"B183*$J$1/1200","v":925.93991664021507},{"$f":"C183-D183","v":5729.2312576068152},{"$f":"B183-E183","v":364646.73539847921},{"$f":"D183/POWER(1+9/1200,A183)","v":239.45719201504104}]
[182,364646.73539847921,6655.1711742470306,911.61683849619794,5743.5543357508323,358903.1810627284,233.99811690766734]
[183,358903.1810627284,6655.1711742470306,897.25795265682098,5757.91322159021,353145.26784113818,228.5979258103502]
[184,353145.26784113818,6655.1711742470306,882.86316960284546,5772.3080046441855,347372.959836494,223.25608983103547]
[185,347372.959836494,6655.1711742470306,868.43239959123503,5786.7387746557961,341586.22106183821,217.97208446420805]
[186,341586.22106183821,6655.1711742470306,853.96555265459551,5801.2056215924349,335785.0154402458,212.74538955600775]
[187,335785.0154402458,6655.1711742470306,839.46253860061449,5815.708635646416,329969.30680459936,207.57548926961556]
[188,329969.30680459936,6655.1711742470306,824.92326701149841,5830.2479072355327,324139.05889736384,202.46187205090894]
[189,324139.05889736384,6655.1711742470306,810.3476472434096,5844.8235270036212,318294.2353703602,197.4040305943835]
[190,318294.2353703602,6655.1711742470306,795.73558842590046,5859.4355858211302,312434.79978453909,192.40146180933922]
[191,312434.79978453909,6655.1711742470306,781.08699946134777,5874.084174785683,306560.71560975339,187.45366678632968]
[192,306560.71560975339,6655.1711742470306,766.40178902438345,5888.7693852226475,300671.94622453075,182.56015076387132]
[193,300671.94622453075,6655.1711742470306,751.67986556132689,5903.4913086857041,294768.45491584507,177.72042309541141]
[194,294768.45491584507,6655.1711742470306,736.92113728961272,5918.2500369574182,288850.20487888763,172.93399721655283]
[{"$f":"A196+1","v":195},288850.20487888763,6655.1711742470306,722.12551219721911,5933.0456620498117,282917.15921683784,168.2003906125332]
[196,282917.15921683784,6655.1711742470306,707.29289804209463,5947.8782762049359,276969.28094063292,163.51912478595699]
[197,276969.28094063292,6655.1711742470306,692.42320235158229,5962.7479718954482,271006.53296873748,158.88972522477786]
[198,271006.53296873748,6655.1711742470306,677.51633242184369,5977.6548418251868,265028.87812691228,154.31172137053034]
[199,265028.87812691228,6655.1711742470306,662.57219531728072,5992.59897892975,259036.27914798254,149.78464658680824]
[200,259036.27914798254,6655.1711742470306,647.59069786995633,6007.5804763770739,253028.69867160547,145.30803812798794]
[201,253028.69867160547,6655.1711742470306,632.5717466790137,6022.5994275680168,247006.09924403744,140.88143710819509]
[202,247006.09924403744,6655.1711742470306,617.51524811009358,6037.6559261369366,240968.4433179005,136.50438847051225]
[203,240968.4433179005,6655.1711742470306,602.42110829475121,6052.7500659522793,234915.69325194822,132.17644095642652]
[204,234915.69325194822,6655.1711742470306,587.28923312987058,6067.8819411171598,228847.81131083105,127.89714707551424]
[205,228847.81131083105,6655.1711742470306,572.11952827707762,6083.0516459699529,222764.75966486111,123.66606307536163]
[206,222764.75966486111,6655.1711742470306,556.91189916215274,6098.259275084878,216666.50038977622,119.4827489117196]
[207,216666.50038977622,6655.1711742470306,541.66625097444057,6113.5049232725905,210552.99546650363,115.34676821889073]
[208,210552.99546650363,6655.1711742470306,526.38248866625906,6128.7886855807719,204424.20678092286,111.25768828034629]
[209,204424.20678092286,6655.1711742470306,511.06051695230718,6144.1106572947238,198280.09612362814,107.21507999957238]
[210,198280.09612362814,6655.1711742470306,495.70024030907041,6159.4709339379606,192120.62518969018,103.21851787114271]
[211,192120.62518969018,6655.1711742470306,480.30156297422548,6174.8696112728048,185945.75557841739,99.267579952016646]
[212,185945.75557841739,6655.1711742470306,464.8643889460435,6190.306785300987,179755.4487931164,95.361847833060594]
[213,179755.4487931164,6655.1711742470306,449.38862198279105,6205.7825522642397,173549.66624085215,91.500906610791219]
[214,173549.66624085215,6655.1711742470306,433.8741656021304,6221.2970086449004,167328.36923220725,87.684344859338509]
[215,167328.36923220725,6655.1711742470306,418.32092308051813,6236.8502511665129,161091.51898104075,83.911754602627624]
[216,161091.51898104075,6655.1711742470306,402.72879745260184,6252.442376794429,154839.07660424631,80.182731286776615]
[217,154839.07660424631,6655.1711742470306,387.09769151061579,6268.0734827364149,148571.00312150989,76.496873752710016]
[218,148571.00312150989,6655.1711742470306,371.42750780377469,6283.7436664432562,142287.25945506664,72.853784208985232]
[219,142287.25945506664,6655.1711742470306,355.71814863766662,6299.453025609364,135987.80642945727,69.253068204830853]
[220,135987.80642945727,6655.1711742470306,339.96951607364315,6315.2016581733878,129672.60477128388,65.694334603395021]
[221,129672.60477128388,6655.1711742470306,324.18151192820972,6330.9896623188206,123341.61510896505,62.177195555202339]
[222,123341.61510896505,6655.1711742470306,308.3540377724126,6346.8171364746177,116994.79797249043,58.701266471817533]
[223,116994.79797249043,6655.1711742470306,292.48699493122609,6362.6841793158046,110632.11379317462,55.266165999714701]
[224,110632.11379317462,6655.1711742470306,276.58028448293658,6378.5908897640938,104253.52290341053,51.871515994349906]
[225,104253.52290341053,6655.1711742470306,260.6338072585263,6394.5373669885048,97858.985536422028,48.51694149443621]
[226,97858.985536422028,6655.1711742470306,244.6474638410551,6410.5237104059752,91448.46182601605,45.202070696419348]
[227,91448.46182601605,6655.1711742470306,228.62115456504009,6426.5500196819903,85021.911806334057,41.926534929152226]
[228,85021.911806334057,6655.1711742470306,212.55477951583515,6442.6163947311952,78579.295411602856,38.689968628767282]
[229,78579.295411602856,6655.1711742470306,196.44823852900714,6458.7229357180231,72120.572475884837,35.492009313744603]
[230,72120.572475884837,6655.1711742470306,180.3014311897121,6474.8697430573184,65645.702732827514,32.332297560174787]
[231,65645.702732827514,6655.1711742470306,164.11425683206878,6491.0569174149623,59154.64581541255,29.210476977214729]
[232,59154.64581541255,6655.1711742470306,147.88661453853138,6507.2845597084997,52647.361255704047,26.126194182735013]
[233,52647.361255704047,6655.1711742470306,131.61840313926012,6523.5527711077702,46123.808484596273,23.079098779157363]
[234,46123.808484596273,6655.1711742470306,115.30952121149069,6539.8616530355403,39583.94683156073,20.068843329480739]
[235,39583.94683156073,6655.1711742470306,98.959867078901837,6556.2113071681288,33027.735524392599,17.095083333494639]
[236,33027.735524392599,6655.1711742470306,82.569338810981492,6572.6018354360494,26455.13368895655,14.157477204178088]
[237,26455.13368895655,6655.1711742470306,66.137834222391362,6589.0333400246391,19866.100348931912,11.255686244283011]
[238,19866.100348931912,6655.1711742470306,49.665250872329779,6605.5059233747006,13260.59442555721,8.3893746231004673]
[239,{"$f":"IF(F240>0,F240,0)","v":13260.59442555721},{"$f":"IF(B241>0,C240,0)","v":6655.1711742470306},{"$f":"B241*$J$1/1200","v":33.151486063893024},{"$f":"C241-D241","v":6622.019688183138},{"$f":"B241-E241","v":6638.5747373740724},{"$f":"D241/POWER(1+9/1200,A241)","v":5.5582093534084045}]
[240,6638.5747373740724,6655.1711742470306,16.596436843435178,6638.5747374035955,-2.9523107514251024E-8,2.7618602685995111]
[null,null,{"$f":"SUM(C3:C242)","v":1597241.0818192912},{"$f":"SUM(D3:D242)","v":397241.08181925875},1200000.0000000291]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Please enable macros"]